package com.xie.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xie.pojo.Dept;
import com.xie.pojo.Vo.DeptVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface DeptDao  extends BaseMapper<Dept> {

    @Select("SELECT dept.dept_id,dept.dept_name,dept.dept_manager,dept.dept_viceManager,personnel.emp_no,personnel.emp_name,personnel.emp_state,personnel.emp_teleNo,personnel.emp_duty FROM dept,personnel where dept.dept_no = personnel.emp_deptId")
    List<DeptVo> findDeptPersonnel();//查询班级人员信息

}
